Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 3616 |
| Missing cells | 6282 |
| Missing cells (%) | 7.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 625.2 KiB |
| Average record size in memory | 177.0 B |
Variable types
| Numeric | 5 |
|---|---|
| Text | 6 |
| Categorical | 6 |
| Boolean | 5 |
| Unsupported | 1 |
Pharmacy_open_to_public_ has constant value "" | Constant |
Fuel_Station_open_to_public_ has constant value "" | Constant |
Online_grocery_pickup has constant value "" | Constant |
objectid is highly overall correlated with businessunit_type_description | High correlation |
businessunit_number is highly overall correlated with bu_num and 2 other fields | High correlation |
bu_num is highly overall correlated with businessunit_number and 2 other fields | High correlation |
businessunit_banner_description is highly overall correlated with businessunit_number and 2 other fields | High correlation |
businessunit_type_description is highly overall correlated with objectid and 3 other fields | High correlation |
businessunit_isstoreopen is highly overall correlated with businessunit_status_code | High correlation |
businessunit_status_code is highly overall correlated with businessunit_isstoreopen | High correlation |
Grocery_delivery_status is highly overall correlated with Online_grocery_pickup_status | High correlation |
Online_grocery_pickup_status is highly overall correlated with Grocery_delivery_status | High correlation |
businessunit_banner_description is highly imbalanced (55.3%) | Imbalance |
businessunit_isstoreopen is highly imbalanced (97.0%) | Imbalance |
businessunit_status_code is highly imbalanced (55.5%) | Imbalance |
op_status is highly imbalanced (99.0%) | Imbalance |
Modified_Operating_Hours_ has 3616 (100.0%) missing values | Missing |
Grocery_delivery_service has 285 (7.9%) missing values | Missing |
Grocery_delivery_status has 1466 (40.5%) missing values | Missing |
Online_grocery_pickup_status has 915 (25.3%) missing values | Missing |
X has unique values | Unique |
objectid has unique values | Unique |
businessunit_number has unique values | Unique |
bu_num has unique values | Unique |
Modified_Operating_Hours_ is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2023-10-22 10:06:48.549054 |
|---|---|
| Analysis finished | 2023-10-22 10:06:54.622671 |
| Duration | 6.07 seconds |
| Software version | ydata-profiling vv4.6.0 |
| Download configuration | config.json |
X
Real number (ℝ)
UNIQUE 
| Distinct | 3616 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -91.717028 |
| Minimum | -159.36503 |
|---|---|
| Maximum | -65.807268 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 3616 |
| Negative (%) | 100.0% |
| Memory size | 28.4 KiB |
Quantile statistics
| Minimum | -159.36503 |
|---|---|
| 5-th percentile | -119.75631 |
| Q1 | -97.333506 |
| median | -88.603161 |
| Q3 | -81.707137 |
| 95-th percentile | -74.572568 |
| Maximum | -65.807268 |
| Range | 93.557757 |
| Interquartile range (IQR) | 15.626369 |
Descriptive statistics
| Standard deviation | 13.812807 |
|---|---|
| Coefficient of variation (CV) | -0.15060243 |
| Kurtosis | 1.2294653 |
| Mean | -91.717028 |
| Median Absolute Deviation (MAD) | 7.7241095 |
| Skewness | -1.0507789 |
| Sum | -331648.77 |
| Variance | 190.79364 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -94.149054 | 1 | < 0.1% |
| -83.470749 | 1 | < 0.1% |
| -80.963031 | 1 | < 0.1% |
| -77.306007 | 1 | < 0.1% |
| -122.983962 | 1 | < 0.1% |
| -80.332788 | 1 | < 0.1% |
| -97.464612 | 1 | < 0.1% |
| -82.924041 | 1 | < 0.1% |
| -119.359391 | 1 | < 0.1% |
| -79.091184 | 1 | < 0.1% |
| Other values (3606) | 3606 |
| Value | Count | Frequency (%) |
| -159.365025 | 1 | |
| -158.034591 | 1 | |
| -158.005571 | 1 | |
| -157.978362 | 1 | |
| -157.974452 | 1 | |
| -157.843233 | 1 | |
| -157.842705 | 1 | |
| -156.454892 | 1 | |
| -155.990922 | 1 | |
| -151.225228 | 1 |
| Value | Count | Frequency (%) |
| -65.807268 | 1 | |
| -65.889641 | 1 | |
| -65.995746 | 1 | |
| -65.997031 | 1 | |
| -66.020899 | 1 | |
| -66.076049 | 1 | |
| -66.087612 | 1 | |
| -66.134127 | 1 | |
| -66.162658 | 1 | |
| -66.627869 | 1 |
Y
Real number (ℝ)
| Distinct | 3615 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.549835 |
| Minimum | 17.993681 |
|---|---|
| Maximum | 64.856378 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 28.4 KiB |
Quantile statistics
| Minimum | 17.993681 |
|---|---|
| 5-th percentile | 28.121938 |
| Q1 | 33.001415 |
| median | 36.177085 |
| Q3 | 40.39249 |
| 95-th percentile | 44.777001 |
| Maximum | 64.856378 |
| Range | 46.862697 |
| Interquartile range (IQR) | 7.3910745 |
Descriptive statistics
| Standard deviation | 5.1954421 |
|---|---|
| Coefficient of variation (CV) | 0.1421468 |
| Kurtosis | 0.64804047 |
| Mean | 36.549835 |
| Median Absolute Deviation (MAD) | 3.6345995 |
| Skewness | 0.015021111 |
| Sum | 132164.2 |
| Variance | 26.992619 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 41.473938 | 2 | 0.1% |
| 36.3313 | 1 | < 0.1% |
| 40.659918 | 1 | < 0.1% |
| 34.944223 | 1 | < 0.1% |
| 35.580506 | 1 | < 0.1% |
| 46.153048 | 1 | < 0.1% |
| 25.746027 | 1 | < 0.1% |
| 37.695454 | 1 | < 0.1% |
| 40.111341 | 1 | < 0.1% |
| 35.604033 | 1 | < 0.1% |
| Other values (3605) | 3605 |
| Value | Count | Frequency (%) |
| 17.993681 | 1 | |
| 17.99736 | 1 | |
| 18.122626 | 1 | |
| 18.141237 | 1 | |
| 18.243301 | 1 | |
| 18.249254 | 1 | |
| 18.380526 | 1 | |
| 18.393823 | 1 | |
| 18.394134 | 1 | |
| 18.411224 | 1 |
| Value | Count | Frequency (%) |
| 64.856378 | 1 | |
| 61.309037 | 1 | |
| 61.211988 | 1 | |
| 61.192239 | 1 | |
| 61.140195 | 1 | |
| 60.564278 | 1 | |
| 55.375474 | 1 | |
| 48.818547 | 1 | |
| 48.801658 | 1 | |
| 48.554783 | 1 |
objectid
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 3616 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32379.427 |
| Minimum | 29040 |
|---|---|
| Maximum | 36706 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 28.4 KiB |
Quantile statistics
| Minimum | 29040 |
|---|---|
| 5-th percentile | 29357.75 |
| Q1 | 30462.5 |
| median | 32084 |
| Q3 | 34209.25 |
| 95-th percentile | 36290 |
| Maximum | 36706 |
| Range | 7666 |
| Interquartile range (IQR) | 3746.75 |
Descriptive statistics
| Standard deviation | 2177.0878 |
|---|---|
| Coefficient of variation (CV) | 0.06723676 |
| Kurtosis | -1.0862057 |
| Mean | 32379.427 |
| Median Absolute Deviation (MAD) | 1868.5 |
| Skewness | 0.29154817 |
| Sum | 1.1708401 × 108 |
| Variance | 4739711.2 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 29040 | 1 | < 0.1% |
| 33535 | 1 | < 0.1% |
| 33487 | 1 | < 0.1% |
| 33489 | 1 | < 0.1% |
| 33491 | 1 | < 0.1% |
| 33492 | 1 | < 0.1% |
| 33493 | 1 | < 0.1% |
| 33495 | 1 | < 0.1% |
| 33497 | 1 | < 0.1% |
| 33498 | 1 | < 0.1% |
| Other values (3606) | 3606 |
| Value | Count | Frequency (%) |
| 29040 | 1 | |
| 29045 | 1 | |
| 29046 | 1 | |
| 29047 | 1 | |
| 29048 | 1 | |
| 29049 | 1 | |
| 29050 | 1 | |
| 29053 | 1 | |
| 29056 | 1 | |
| 29057 | 1 |
| Value | Count | Frequency (%) |
| 36706 | 1 | |
| 36705 | 1 | |
| 36704 | 1 | |
| 36702 | 1 | |
| 36700 | 1 | |
| 36698 | 1 | |
| 36695 | 1 | |
| 36693 | 1 | |
| 36690 | 1 | |
| 36688 | 1 |
| Distinct | 3385 |
|---|---|
| Distinct (%) | 93.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
Length
| Max length | 42 |
|---|---|
| Median length | 32 |
| Mean length | 13.925608 |
| Min length | 6 |
Characters and Unicode
| Total characters | 50355 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3189 ? |
|---|---|
| Unique (%) | 88.2% |
Sample
| 1st row | ROGERS, AR |
|---|---|
| 2nd row | PONCE-PR |
| 3rd row | BROWNSVILLE TX |
| 4th row | LAVALE, MD |
| 5th row | PUEBLO, CO |
| Value | Count | Frequency (%) |
| tx | 391 | 4.3% |
| fl | 241 | 2.7% |
| ca | 219 | 2.4% |
| nc | 141 | 1.6% |
| ga | 134 | 1.5% |
| la | 122 | 1.3% |
| oh | 117 | 1.3% |
| il | 117 | 1.3% |
| tn | 113 | 1.2% |
| pa | 108 | 1.2% |
| Other values (2521) | 7353 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5446 | 10.8% | |
| A | 4351 | 8.6% |
| N | 3504 | 7.0% |
| E | 3470 | 6.9% |
| L | 3333 | 6.6% |
| O | 3184 | 6.3% |
| I | 2599 | 5.2% |
| R | 2539 | 5.0% |
| T | 2487 | 4.9% |
| S | 2401 | 4.8% |
| Other values (60) | 17041 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 41311 | |
| Space Separator | 5446 | 10.8% |
| Other Punctuation | 1835 | 3.6% |
| Lowercase Letter | 587 | 1.2% |
| Close Punctuation | 489 | 1.0% |
| Open Punctuation | 489 | 1.0% |
| Decimal Number | 154 | 0.3% |
| Dash Punctuation | 43 | 0.1% |
| Modifier Symbol | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 4351 | 10.5% |
| N | 3504 | 8.5% |
| E | 3470 | 8.4% |
| L | 3333 | 8.1% |
| O | 3184 | 7.7% |
| I | 2599 | 6.3% |
| R | 2539 | 6.1% |
| T | 2487 | 6.0% |
| S | 2401 | 5.8% |
| C | 1768 | 4.3% |
| Other values (16) | 11675 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 71 | |
| e | 64 | |
| o | 60 | |
| r | 53 | |
| n | 51 | |
| l | 48 | 8.2% |
| s | 33 | 5.6% |
| t | 30 | 5.1% |
| i | 28 | 4.8% |
| d | 23 | 3.9% |
| Other values (14) | 126 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 54 | |
| 2 | 29 | |
| 0 | 20 | 13.0% |
| 3 | 11 | 7.1% |
| 7 | 10 | 6.5% |
| 6 | 8 | 5.2% |
| 5 | 8 | 5.2% |
| 4 | 8 | 5.2% |
| 8 | 5 | 3.2% |
| 9 | 1 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 1718 | |
| . | 59 | 3.2% |
| / | 29 | 1.6% |
| & | 26 | 1.4% |
| ' | 3 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 5446 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 489 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 489 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 43 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 41898 | |
| Common | 8457 | 16.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 4351 | 10.4% |
| N | 3504 | 8.4% |
| E | 3470 | 8.3% |
| L | 3333 | 8.0% |
| O | 3184 | 7.6% |
| I | 2599 | 6.2% |
| R | 2539 | 6.1% |
| T | 2487 | 5.9% |
| S | 2401 | 5.7% |
| C | 1768 | 4.2% |
| Other values (40) | 12262 |
Common
| Value | Count | Frequency (%) |
| 5446 | ||
| , | 1718 | 20.3% |
| ) | 489 | 5.8% |
| ( | 489 | 5.8% |
| . | 59 | 0.7% |
| 1 | 54 | 0.6% |
| - | 43 | 0.5% |
| / | 29 | 0.3% |
| 2 | 29 | 0.3% |
| & | 26 | 0.3% |
| Other values (10) | 75 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 50355 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5446 | 10.8% | |
| A | 4351 | 8.6% |
| N | 3504 | 7.0% |
| E | 3470 | 6.9% |
| L | 3333 | 6.6% |
| O | 3184 | 6.3% |
| I | 2599 | 5.2% |
| R | 2539 | 5.0% |
| T | 2487 | 4.9% |
| S | 2401 | 4.8% |
| Other values (60) | 17041 |
businessunit_number
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 3616 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3149.1341 |
| Minimum | 1 |
|---|---|
| Maximum | 9894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 28.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 272.75 |
| Q1 | 1329.5 |
| median | 2732.5 |
| Q3 | 4871.25 |
| 95-th percentile | 6938 |
| Maximum | 9894 |
| Range | 9893 |
| Interquartile range (IQR) | 3541.75 |
Descriptive statistics
| Standard deviation | 2164.8546 |
|---|---|
| Coefficient of variation (CV) | 0.6874444 |
| Kurtosis | -0.69570333 |
| Mean | 3149.1341 |
| Median Absolute Deviation (MAD) | 1681.5 |
| Skewness | 0.51084009 |
| Sum | 11387269 |
| Variance | 4686595.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 5893 | 1 | < 0.1% |
| 585 | 1 | < 0.1% |
| 5851 | 1 | < 0.1% |
| 5853 | 1 | < 0.1% |
| 5854 | 1 | < 0.1% |
| 5855 | 1 | < 0.1% |
| 5857 | 1 | < 0.1% |
| 5859 | 1 | < 0.1% |
| 586 | 1 | < 0.1% |
| Other values (3606) | 3606 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 8 | 1 | |
| 12 | 1 | |
| 14 | 1 | |
| 17 | 1 | |
| 18 | 1 | |
| 19 | 1 |
| Value | Count | Frequency (%) |
| 9894 | 1 | |
| 8331 | 1 | |
| 8299 | 1 | |
| 8298 | 1 | |
| 8297 | 1 | |
| 8295 | 1 | |
| 8294 | 1 | |
| 8293 | 1 | |
| 8292 | 1 | |
| 8290 | 1 |
businessunit_banner_description
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
| WM Supercenter | |
|---|---|
| Sam's Club | |
| Neighborhood Market | |
| Wal-Mart | 242 |
| Walmart Fuel Station | 3 |
| Other values (3) | 3 |
Length
| Max length | 26 |
|---|---|
| Median length | 14 |
| Mean length | 13.649889 |
| Min length | 8 |
Characters and Unicode
| Total characters | 49358 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | WM Supercenter |
|---|---|
| 2nd row | WM Supercenter |
| 3rd row | WM Supercenter |
| 4th row | WM Supercenter |
| 5th row | WM Supercenter |
Common Values
| Value | Count | Frequency (%) |
| WM Supercenter | 2555 | |
| Sam's Club | 436 | 12.1% |
| Neighborhood Market | 377 | 10.4% |
| Wal-Mart | 242 | 6.7% |
| Walmart Fuel Station | 3 | 0.1% |
| WM On Campus/RX Facilities | 1 | < 0.1% |
| WM ONLINE PICKUP/DELIVERY | 1 | < 0.1% |
| STAND ALONE PICKUP | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| wm | 2557 | |
| supercenter | 2555 | |
| sam's | 436 | 6.2% |
| club | 436 | 6.2% |
| neighborhood | 377 | 5.4% |
| market | 377 | 5.4% |
| wal-mart | 242 | 3.5% |
| fuel | 3 | < 0.1% |
| station | 3 | < 0.1% |
| walmart | 3 | < 0.1% |
| Other values (8) | 8 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8423 | |
| r | 6109 | |
| 3381 | 6.8% | |
| t | 3184 | 6.5% |
| M | 3176 | 6.4% |
| S | 2995 | 6.1% |
| u | 2995 | 6.1% |
| W | 2802 | 5.7% |
| n | 2559 | 5.2% |
| p | 2556 | 5.2% |
| Other values (32) | 11178 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35468 | |
| Uppercase Letter | 9829 | 19.9% |
| Space Separator | 3381 | 6.8% |
| Other Punctuation | 438 | 0.9% |
| Dash Punctuation | 242 | 0.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 3176 | |
| S | 2995 | |
| W | 2802 | |
| C | 439 | 4.5% |
| N | 381 | 3.9% |
| F | 4 | < 0.1% |
| I | 4 | < 0.1% |
| E | 4 | < 0.1% |
| P | 4 | < 0.1% |
| O | 3 | < 0.1% |
| Other values (10) | 17 | 0.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 8423 | |
| r | 6109 | |
| t | 3184 | 9.0% |
| u | 2995 | 8.4% |
| n | 2559 | 7.2% |
| p | 2556 | 7.2% |
| c | 2556 | 7.2% |
| a | 1308 | 3.7% |
| o | 1134 | 3.2% |
| b | 813 | 2.3% |
| Other values (8) | 3831 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 436 | |
| / | 2 | 0.5% |
Space Separator
| Value | Count | Frequency (%) |
| 3381 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 242 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 45297 | |
| Common | 4061 | 8.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 8423 | |
| r | 6109 | |
| t | 3184 | 7.0% |
| M | 3176 | 7.0% |
| S | 2995 | 6.6% |
| u | 2995 | 6.6% |
| W | 2802 | 6.2% |
| n | 2559 | 5.6% |
| p | 2556 | 5.6% |
| c | 2556 | 5.6% |
| Other values (28) | 7942 |
Common
| Value | Count | Frequency (%) |
| 3381 | ||
| ' | 436 | 10.7% |
| - | 242 | 6.0% |
| / | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49358 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 8423 | |
| r | 6109 | |
| 3381 | 6.8% | |
| t | 3184 | 6.5% |
| M | 3176 | 6.4% |
| S | 2995 | 6.1% |
| u | 2995 | 6.1% |
| W | 2802 | 5.7% |
| n | 2559 | 5.2% |
| p | 2556 | 5.2% |
| Other values (32) | 11178 |
businessunit_type_description
Categorical
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
| Retail | |
|---|---|
| Wholesale |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.3617257 |
| Min length | 6 |
Characters and Unicode
| Total characters | 23004 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Retail |
|---|---|
| 2nd row | Retail |
| 3rd row | Retail |
| 4th row | Retail |
| 5th row | Retail |
Common Values
| Value | Count | Frequency (%) |
| Retail | 3180 | |
| Wholesale | 436 | 12.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| retail | 3180 | |
| wholesale | 436 | 12.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4052 | |
| l | 4052 | |
| a | 3616 | |
| R | 3180 | |
| t | 3180 | |
| i | 3180 | |
| W | 436 | 1.9% |
| h | 436 | 1.9% |
| o | 436 | 1.9% |
| s | 436 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 19388 | |
| Uppercase Letter | 3616 | 15.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4052 | |
| l | 4052 | |
| a | 3616 | |
| t | 3180 | |
| i | 3180 | |
| h | 436 | 2.2% |
| o | 436 | 2.2% |
| s | 436 | 2.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 3180 | |
| W | 436 | 12.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23004 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4052 | |
| l | 4052 | |
| a | 3616 | |
| R | 3180 | |
| t | 3180 | |
| i | 3180 | |
| W | 436 | 1.9% |
| h | 436 | 1.9% |
| o | 436 | 1.9% |
| s | 436 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23004 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 4052 | |
| l | 4052 | |
| a | 3616 | |
| R | 3180 | |
| t | 3180 | |
| i | 3180 | |
| W | 436 | 1.9% |
| h | 436 | 1.9% |
| o | 436 | 1.9% |
| s | 436 | 1.9% |
businessunit_isstoreopen
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 KiB |
| True | |
|---|---|
| False | 11 |
| Value | Count | Frequency (%) |
| True | 3605 | |
| False | 11 | 0.3% |
| Distinct | 3609 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
Length
| Max length | 41 |
|---|---|
| Median length | 34 |
| Mean length | 17.716261 |
| Min length | 9 |
Characters and Unicode
| Total characters | 64062 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 3604 ? |
|---|---|
| Unique (%) | 99.7% |
Sample
| 1st row | 2110 W WALNUT ST |
|---|---|
| 2nd row | 3305 AVE.BARAMAYA SUITE 100 |
| 3rd row | 2721 BOCA CHICA BLVD |
| 4th row | 12500 COUNTRY CLUB MALL RD |
| 5th row | 4080 W NORTHERN AVE |
| Value | Count | Frequency (%) |
| rd | 691 | 5.1% |
| st | 549 | 4.0% |
| ave | 410 | 3.0% |
| blvd | 410 | 3.0% |
| dr | 378 | 2.8% |
| s | 368 | 2.7% |
| n | 344 | 2.5% |
| e | 335 | 2.5% |
| w | 334 | 2.5% |
| highway | 243 | 1.8% |
| Other values (4419) | 9500 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9946 | 15.5% | |
| E | 3857 | 6.0% |
| R | 3403 | 5.3% |
| A | 3336 | 5.2% |
| 0 | 3130 | 4.9% |
| 1 | 2875 | 4.5% |
| S | 2655 | 4.1% |
| N | 2584 | 4.0% |
| T | 2454 | 3.8% |
| L | 2390 | 3.7% |
| Other values (42) | 27432 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 38821 | |
| Decimal Number | 15194 | 23.7% |
| Space Separator | 9946 | 15.5% |
| Other Punctuation | 72 | 0.1% |
| Dash Punctuation | 19 | < 0.1% |
| Lowercase Letter | 10 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 3857 | 9.9% |
| R | 3403 | 8.8% |
| A | 3336 | 8.6% |
| S | 2655 | 6.8% |
| N | 2584 | 6.7% |
| T | 2454 | 6.3% |
| L | 2390 | 6.2% |
| D | 2387 | 6.1% |
| O | 2064 | 5.3% |
| I | 1886 | 4.9% |
| Other values (17) | 11805 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3130 | |
| 1 | 2875 | |
| 5 | 1779 | |
| 2 | 1762 | |
| 3 | 1313 | |
| 4 | 1104 | 7.3% |
| 7 | 876 | 5.8% |
| 6 | 863 | 5.7% |
| 9 | 748 | 4.9% |
| 8 | 744 | 4.9% |
Lowercase Letter
| Value | Count | Frequency (%) |
| y | 2 | |
| d | 2 | |
| k | 1 | |
| w | 1 | |
| c | 1 | |
| a | 1 | |
| m | 1 | |
| e | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 66 | |
| , | 2 | 2.8% |
| # | 2 | 2.8% |
| / | 1 | 1.4% |
| ' | 1 | 1.4% |
Space Separator
| Value | Count | Frequency (%) |
| 9946 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 38831 | |
| Common | 25231 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 3857 | 9.9% |
| R | 3403 | 8.8% |
| A | 3336 | 8.6% |
| S | 2655 | 6.8% |
| N | 2584 | 6.7% |
| T | 2454 | 6.3% |
| L | 2390 | 6.2% |
| D | 2387 | 6.1% |
| O | 2064 | 5.3% |
| I | 1886 | 4.9% |
| Other values (25) | 11815 |
Common
| Value | Count | Frequency (%) |
| 9946 | ||
| 0 | 3130 | 12.4% |
| 1 | 2875 | 11.4% |
| 5 | 1779 | 7.1% |
| 2 | 1762 | 7.0% |
| 3 | 1313 | 5.2% |
| 4 | 1104 | 4.4% |
| 7 | 876 | 3.5% |
| 6 | 863 | 3.4% |
| 9 | 748 | 3.0% |
| Other values (7) | 835 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 64061 | |
| None | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9946 | 15.5% | |
| E | 3857 | 6.0% |
| R | 3403 | 5.3% |
| A | 3336 | 5.2% |
| 0 | 3130 | 4.9% |
| 1 | 2875 | 4.5% |
| S | 2655 | 4.1% |
| N | 2584 | 4.0% |
| T | 2454 | 3.8% |
| L | 2390 | 3.7% |
| Other values (41) | 27431 |
None
| Value | Count | Frequency (%) |
| Ñ | 1 |
| Distinct | 2073 |
|---|---|
| Distinct (%) | 57.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 8.8279867 |
| Min length | 3 |
Characters and Unicode
| Total characters | 31922 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1453 ? |
|---|---|
| Unique (%) | 40.2% |
Sample
| 1st row | ROGERS |
|---|---|
| 2nd row | PONCE |
| 3rd row | BROWNSVILLE |
| 4th row | LAVALE |
| 5th row | PUEBLO |
| Value | Count | Frequency (%) |
| city | 102 | 2.2% |
| san | 48 | 1.1% |
| springs | 45 | 1.0% |
| beach | 42 | 0.9% |
| north | 34 | 0.7% |
| fort | 33 | 0.7% |
| west | 29 | 0.6% |
| lake | 29 | 0.6% |
| las | 28 | 0.6% |
| saint | 27 | 0.6% |
| Other values (1999) | 4117 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 3056 | 9.6% |
| E | 3018 | 9.5% |
| O | 2618 | 8.2% |
| L | 2564 | 8.0% |
| N | 2526 | 7.9% |
| R | 2226 | 7.0% |
| I | 2027 | 6.3% |
| S | 1883 | 5.9% |
| T | 1739 | 5.4% |
| C | 1076 | 3.4% |
| Other values (18) | 9189 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 31003 | |
| Space Separator | 918 | 2.9% |
| Dash Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3056 | 9.9% |
| E | 3018 | 9.7% |
| O | 2618 | 8.4% |
| L | 2564 | 8.3% |
| N | 2526 | 8.1% |
| R | 2226 | 7.2% |
| I | 2027 | 6.5% |
| S | 1883 | 6.1% |
| T | 1739 | 5.6% |
| C | 1076 | 3.5% |
| Other values (16) | 8270 |
Space Separator
| Value | Count | Frequency (%) |
| 918 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 31003 | |
| Common | 919 | 2.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 3056 | 9.9% |
| E | 3018 | 9.7% |
| O | 2618 | 8.4% |
| L | 2564 | 8.3% |
| N | 2526 | 8.1% |
| R | 2226 | 7.2% |
| I | 2027 | 6.5% |
| S | 1883 | 6.1% |
| T | 1739 | 5.6% |
| C | 1076 | 3.5% |
| Other values (16) | 8270 |
Common
| Value | Count | Frequency (%) |
| 918 | ||
| - | 1 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31922 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 3056 | 9.6% |
| E | 3018 | 9.5% |
| O | 2618 | 8.2% |
| L | 2564 | 8.0% |
| N | 2526 | 7.9% |
| R | 2226 | 7.0% |
| I | 2027 | 6.3% |
| S | 1883 | 5.9% |
| T | 1739 | 5.4% |
| C | 1076 | 3.4% |
| Other values (18) | 9189 |
| Distinct | 1034 |
|---|---|
| Distinct (%) | 28.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 25 |
| Mean length | 7.3653208 |
| Min length | 3 |
Characters and Unicode
| Total characters | 26633 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 493 ? |
|---|---|
| Unique (%) | 13.6% |
Sample
| 1st row | BENTON |
|---|---|
| 2nd row | PONCE |
| 3rd row | CAMERON |
| 4th row | ALLEGANY |
| 5th row | PUEBLO |
| Value | Count | Frequency (%) |
| st | 66 | 1.6% |
| san | 50 | 1.2% |
| orange | 46 | 1.1% |
| jefferson | 45 | 1.1% |
| washington | 43 | 1.1% |
| maricopa | 41 | 1.0% |
| dallas | 40 | 1.0% |
| harris | 37 | 0.9% |
| clark | 36 | 0.9% |
| city | 35 | 0.9% |
| Other values (1051) | 3596 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 3043 | |
| E | 2492 | 9.4% |
| O | 2228 | 8.4% |
| N | 2179 | 8.2% |
| R | 1969 | 7.4% |
| L | 1809 | 6.8% |
| S | 1614 | 6.1% |
| I | 1454 | 5.5% |
| T | 1253 | 4.7% |
| C | 995 | 3.7% |
| Other values (26) | 7597 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 26123 | |
| Space Separator | 420 | 1.6% |
| Other Punctuation | 70 | 0.3% |
| Dash Punctuation | 13 | < 0.1% |
| Lowercase Letter | 7 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3043 | |
| E | 2492 | 9.5% |
| O | 2228 | 8.5% |
| N | 2179 | 8.3% |
| R | 1969 | 7.5% |
| L | 1809 | 6.9% |
| S | 1614 | 6.2% |
| I | 1454 | 5.6% |
| T | 1253 | 4.8% |
| C | 995 | 3.8% |
| Other values (16) | 7087 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2 | |
| a | 1 | |
| w | 1 | |
| r | 1 | |
| n | 1 | |
| c | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 66 | |
| ' | 4 | 5.7% |
Space Separator
| Value | Count | Frequency (%) |
| 420 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 26130 | |
| Common | 503 | 1.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 3043 | |
| E | 2492 | 9.5% |
| O | 2228 | 8.5% |
| N | 2179 | 8.3% |
| R | 1969 | 7.5% |
| L | 1809 | 6.9% |
| S | 1614 | 6.2% |
| I | 1454 | 5.6% |
| T | 1253 | 4.8% |
| C | 995 | 3.8% |
| Other values (22) | 7094 |
Common
| Value | Count | Frequency (%) |
| 420 | ||
| . | 66 | 13.1% |
| - | 13 | 2.6% |
| ' | 4 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26633 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 3043 | |
| E | 2492 | 9.4% |
| O | 2228 | 8.4% |
| N | 2179 | 8.2% |
| R | 1969 | 7.4% |
| L | 1809 | 6.8% |
| S | 1614 | 6.1% |
| I | 1454 | 5.5% |
| T | 1253 | 4.7% |
| C | 995 | 3.7% |
| Other values (26) | 7597 |
| Distinct | 52 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 7232 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AR |
|---|---|
| 2nd row | PR |
| 3rd row | TX |
| 4th row | MD |
| 5th row | CO |
| Value | Count | Frequency (%) |
| tx | 400 | 11.1% |
| fl | 250 | 6.9% |
| ca | 222 | 6.1% |
| nc | 145 | 4.0% |
| ga | 135 | 3.7% |
| oh | 120 | 3.3% |
| il | 120 | 3.3% |
| tn | 116 | 3.2% |
| va | 110 | 3.0% |
| pa | 109 | 3.0% |
| Other values (42) | 1889 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1082 | |
| N | 663 | 9.2% |
| T | 585 | 8.1% |
| L | 574 | 7.9% |
| C | 556 | 7.7% |
| M | 475 | 6.6% |
| O | 440 | 6.1% |
| I | 430 | 5.9% |
| X | 400 | 5.5% |
| F | 250 | 3.5% |
| Other values (14) | 1777 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7232 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1082 | |
| N | 663 | 9.2% |
| T | 585 | 8.1% |
| L | 574 | 7.9% |
| C | 556 | 7.7% |
| M | 475 | 6.6% |
| O | 440 | 6.1% |
| I | 430 | 5.9% |
| X | 400 | 5.5% |
| F | 250 | 3.5% |
| Other values (14) | 1777 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7232 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 1082 | |
| N | 663 | 9.2% |
| T | 585 | 8.1% |
| L | 574 | 7.9% |
| C | 556 | 7.7% |
| M | 475 | 6.6% |
| O | 440 | 6.1% |
| I | 430 | 5.9% |
| X | 400 | 5.5% |
| F | 250 | 3.5% |
| Other values (14) | 1777 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7232 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 1082 | |
| N | 663 | 9.2% |
| T | 585 | 8.1% |
| L | 574 | 7.9% |
| C | 556 | 7.7% |
| M | 475 | 6.6% |
| O | 440 | 6.1% |
| I | 430 | 5.9% |
| X | 400 | 5.5% |
| F | 250 | 3.5% |
| Other values (14) | 1777 |
| Distinct | 3572 |
|---|---|
| Distinct (%) | 98.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 36160 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3528 ? |
|---|---|
| Unique (%) | 97.6% |
Sample
| 1st row | 72756-3246 |
|---|---|
| 2nd row | 00728-0000 |
| 3rd row | 78521-3501 |
| 4th row | 21502-7553 |
| 5th row | 81005-3503 |
| Value | Count | Frequency (%) |
| 27407-2600 | 2 | 0.1% |
| 39402-8854 | 2 | 0.1% |
| 23602-4311 | 2 | 0.1% |
| 37923-3115 | 2 | 0.1% |
| 29910-7621 | 2 | 0.1% |
| 70058-3405 | 2 | 0.1% |
| 21801-2143 | 2 | 0.1% |
| 63303-3526 | 2 | 0.1% |
| 51501-7672 | 2 | 0.1% |
| 29621-1344 | 2 | 0.1% |
| Other values (3562) | 3596 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4738 | |
| 1 | 3758 | |
| 3 | 3650 | |
| 2 | 3631 | |
| - | 3616 | |
| 4 | 3171 | |
| 7 | 3036 | |
| 5 | 3025 | |
| 6 | 2802 | |
| 8 | 2496 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 32544 | |
| Dash Punctuation | 3616 | 10.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4738 | |
| 1 | 3758 | |
| 3 | 3650 | |
| 2 | 3631 | |
| 4 | 3171 | |
| 7 | 3036 | |
| 5 | 3025 | |
| 6 | 2802 | |
| 8 | 2496 | |
| 9 | 2237 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3616 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 36160 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4738 | |
| 1 | 3758 | |
| 3 | 3650 | |
| 2 | 3631 | |
| - | 3616 | |
| 4 | 3171 | |
| 7 | 3036 | |
| 5 | 3025 | |
| 6 | 2802 | |
| 8 | 2496 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36160 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4738 | |
| 1 | 3758 | |
| 3 | 3650 | |
| 2 | 3631 | |
| - | 3616 | |
| 4 | 3171 | |
| 7 | 3036 | |
| 5 | 3025 | |
| 6 | 2802 | |
| 8 | 2496 |
businessunit_status_code
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
| 5 | |
|---|---|
| 2 | |
| 6 | 11 |
| 4 | 1 |
| 3 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3616 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 5 |
|---|---|
| 2nd row | 5 |
| 3rd row | 5 |
| 4th row | 5 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 5 | 1857 | |
| 2 | 1746 | |
| 6 | 11 | 0.3% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5 | 1857 | |
| 2 | 1746 | |
| 6 | 11 | 0.3% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 1857 | |
| 2 | 1746 | |
| 6 | 11 | 0.3% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3616 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 1857 | |
| 2 | 1746 | |
| 6 | 11 | 0.3% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3616 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 1857 | |
| 2 | 1746 | |
| 6 | 11 | 0.3% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3616 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 1857 | |
| 2 | 1746 | |
| 6 | 11 | 0.3% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
op_status
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
| Open | |
|---|---|
| Closed | 3 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.0016593 |
| Min length | 4 |
Characters and Unicode
| Total characters | 14470 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Open |
|---|---|
| 2nd row | Open |
| 3rd row | Open |
| 4th row | Open |
| 5th row | Open |
Common Values
| Value | Count | Frequency (%) |
| Open | 3613 | |
| Closed | 3 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| open | 3613 | |
| closed | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 3616 | |
| O | 3613 | |
| p | 3613 | |
| n | 3613 | |
| C | 3 | < 0.1% |
| l | 3 | < 0.1% |
| o | 3 | < 0.1% |
| s | 3 | < 0.1% |
| d | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 10854 | |
| Uppercase Letter | 3616 | 25.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3616 | |
| p | 3613 | |
| n | 3613 | |
| l | 3 | < 0.1% |
| o | 3 | < 0.1% |
| s | 3 | < 0.1% |
| d | 3 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 3613 | |
| C | 3 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14470 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3616 | |
| O | 3613 | |
| p | 3613 | |
| n | 3613 | |
| C | 3 | < 0.1% |
| l | 3 | < 0.1% |
| o | 3 | < 0.1% |
| s | 3 | < 0.1% |
| d | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14470 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 3616 | |
| O | 3613 | |
| p | 3613 | |
| n | 3613 | |
| C | 3 | < 0.1% |
| l | 3 | < 0.1% |
| o | 3 | < 0.1% |
| s | 3 | < 0.1% |
| d | 3 | < 0.1% |
Modified_Operating_Hours_
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 3616 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 28.4 KiB |
Pharmacy_open_to_public_
Boolean
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 KiB |
| True |
|---|
| Value | Count | Frequency (%) |
| True | 3616 |
Fuel_Station_open_to_public_
Boolean
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 KiB |
| True |
|---|
| Value | Count | Frequency (%) |
| True | 3616 |
bu_num
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 3616 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3149.1341 |
| Minimum | 1 |
|---|---|
| Maximum | 9894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 28.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 272.75 |
| Q1 | 1329.5 |
| median | 2732.5 |
| Q3 | 4871.25 |
| 95-th percentile | 6938 |
| Maximum | 9894 |
| Range | 9893 |
| Interquartile range (IQR) | 3541.75 |
Descriptive statistics
| Standard deviation | 2164.8546 |
|---|---|
| Coefficient of variation (CV) | 0.6874444 |
| Kurtosis | -0.69570333 |
| Mean | 3149.1341 |
| Median Absolute Deviation (MAD) | 1681.5 |
| Skewness | 0.51084009 |
| Sum | 11387269 |
| Variance | 4686595.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 5893 | 1 | < 0.1% |
| 585 | 1 | < 0.1% |
| 5851 | 1 | < 0.1% |
| 5853 | 1 | < 0.1% |
| 5854 | 1 | < 0.1% |
| 5855 | 1 | < 0.1% |
| 5857 | 1 | < 0.1% |
| 5859 | 1 | < 0.1% |
| 586 | 1 | < 0.1% |
| Other values (3606) | 3606 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 8 | 1 | |
| 12 | 1 | |
| 14 | 1 | |
| 17 | 1 | |
| 18 | 1 | |
| 19 | 1 |
| Value | Count | Frequency (%) |
| 9894 | 1 | |
| 8331 | 1 | |
| 8299 | 1 | |
| 8298 | 1 | |
| 8297 | 1 | |
| 8295 | 1 | |
| 8294 | 1 | |
| 8293 | 1 | |
| 8292 | 1 | |
| 8290 | 1 |
Grocery_delivery_service
Boolean
MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 285 |
| Missing (%) | 7.9% |
| Memory size | 7.2 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 1738 | |
| True | 1593 | |
| (Missing) | 285 | 7.9% |
Grocery_delivery_status
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1466 |
| Missing (%) | 40.5% |
| Memory size | 28.4 KiB |
| Available | |
|---|---|
| Not Available |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.5134884 |
| Min length | 9 |
Characters and Unicode
| Total characters | 20454 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Available |
|---|---|
| 2nd row | Available |
| 3rd row | Available |
| 4th row | Available |
| 5th row | Available |
Common Values
| Value | Count | Frequency (%) |
| Available | 1874 | |
| Not Available | 276 | 7.6% |
| (Missing) | 1466 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| available | 2150 | |
| not | 276 | 11.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4300 | |
| l | 4300 | |
| A | 2150 | |
| v | 2150 | |
| i | 2150 | |
| b | 2150 | |
| e | 2150 | |
| N | 276 | 1.3% |
| o | 276 | 1.3% |
| t | 276 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 17752 | |
| Uppercase Letter | 2426 | 11.9% |
| Space Separator | 276 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4300 | |
| l | 4300 | |
| v | 2150 | |
| i | 2150 | |
| b | 2150 | |
| e | 2150 | |
| o | 276 | 1.6% |
| t | 276 | 1.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2150 | |
| N | 276 | 11.4% |
Space Separator
| Value | Count | Frequency (%) |
| 276 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 20178 | |
| Common | 276 | 1.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4300 | |
| l | 4300 | |
| A | 2150 | |
| v | 2150 | |
| i | 2150 | |
| b | 2150 | |
| e | 2150 | |
| N | 276 | 1.4% |
| o | 276 | 1.4% |
| t | 276 | 1.4% |
Common
| Value | Count | Frequency (%) |
| 276 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20454 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 4300 | |
| l | 4300 | |
| A | 2150 | |
| v | 2150 | |
| i | 2150 | |
| b | 2150 | |
| e | 2150 | |
| N | 276 | 1.3% |
| o | 276 | 1.3% |
| t | 276 | 1.3% |
Online_grocery_pickup
Boolean
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 KiB |
| True |
|---|
| Value | Count | Frequency (%) |
| True | 3616 |
Online_grocery_pickup_status
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 915 |
| Missing (%) | 25.3% |
| Memory size | 28.4 KiB |
| Available | |
|---|---|
| Not Available |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.5035172 |
| Min length | 9 |
Characters and Unicode
| Total characters | 25669 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Available |
|---|---|
| 2nd row | Available |
| 3rd row | Available |
| 4th row | Available |
| 5th row | Available |
Common Values
| Value | Count | Frequency (%) |
| Available | 2361 | |
| Not Available | 340 | 9.4% |
| (Missing) | 915 | 25.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| available | 2701 | |
| not | 340 | 11.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 5402 | |
| l | 5402 | |
| A | 2701 | |
| v | 2701 | |
| i | 2701 | |
| b | 2701 | |
| e | 2701 | |
| N | 340 | 1.3% |
| o | 340 | 1.3% |
| t | 340 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 22288 | |
| Uppercase Letter | 3041 | 11.8% |
| Space Separator | 340 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 5402 | |
| l | 5402 | |
| v | 2701 | |
| i | 2701 | |
| b | 2701 | |
| e | 2701 | |
| o | 340 | 1.5% |
| t | 340 | 1.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2701 | |
| N | 340 | 11.2% |
Space Separator
| Value | Count | Frequency (%) |
| 340 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 25329 | |
| Common | 340 | 1.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 5402 | |
| l | 5402 | |
| A | 2701 | |
| v | 2701 | |
| i | 2701 | |
| b | 2701 | |
| e | 2701 | |
| N | 340 | 1.3% |
| o | 340 | 1.3% |
| t | 340 | 1.3% |
Common
| Value | Count | Frequency (%) |
| 340 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 25669 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 5402 | |
| l | 5402 | |
| A | 2701 | |
| v | 2701 | |
| i | 2701 | |
| b | 2701 | |
| e | 2701 | |
| N | 340 | 1.3% |
| o | 340 | 1.3% |
| t | 340 | 1.3% |
| X | Y | objectid | businessunit_number | bu_num | businessunit_banner_description | businessunit_type_description | businessunit_isstoreopen | businessunit_status_code | op_status | Grocery_delivery_service | Grocery_delivery_status | Online_grocery_pickup_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| X | 1.000 | 0.093 | -0.054 | 0.026 | 0.026 | 0.121 | 0.042 | 0.044 | 0.088 | 0.000 | 0.075 | 0.071 | 0.048 |
| Y | 0.093 | 1.000 | -0.177 | 0.042 | 0.042 | 0.092 | 0.063 | 0.036 | 0.037 | 0.000 | 0.086 | 0.000 | 0.000 |
| objectid | -0.054 | -0.177 | 1.000 | 0.467 | 0.467 | 0.217 | 0.509 | 0.021 | 0.273 | 0.051 | 0.062 | 0.000 | 0.000 |
| businessunit_number | 0.026 | 0.042 | 0.467 | 1.000 | 1.000 | 0.511 | 0.806 | 0.017 | 0.385 | 0.000 | 0.130 | 0.000 | 0.000 |
| bu_num | 0.026 | 0.042 | 0.467 | 1.000 | 1.000 | 0.511 | 0.806 | 0.017 | 0.385 | 0.000 | 0.130 | 0.000 | 0.000 |
| businessunit_banner_description | 0.121 | 0.092 | 0.217 | 0.511 | 0.511 | 1.000 | 0.999 | 0.299 | 0.261 | 0.000 | 0.175 | 0.043 | 0.032 |
| businessunit_type_description | 0.042 | 0.063 | 0.509 | 0.806 | 0.806 | 0.999 | 1.000 | 0.000 | 0.045 | 0.000 | 0.173 | 0.012 | 0.000 |
| businessunit_isstoreopen | 0.044 | 0.036 | 0.021 | 0.017 | 0.017 | 0.299 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| businessunit_status_code | 0.088 | 0.037 | 0.273 | 0.385 | 0.385 | 0.261 | 0.045 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| op_status | 0.000 | 0.000 | 0.051 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 |
| Grocery_delivery_service | 0.075 | 0.086 | 0.062 | 0.130 | 0.130 | 0.175 | 0.173 | 0.000 | 0.000 | 0.000 | 1.000 | 0.315 | 0.251 |
| Grocery_delivery_status | 0.071 | 0.000 | 0.000 | 0.000 | 0.000 | 0.043 | 0.012 | 0.000 | 0.000 | 0.000 | 0.315 | 1.000 | 0.905 |
| Online_grocery_pickup_status | 0.048 | 0.000 | 0.000 | 0.000 | 0.000 | 0.032 | 0.000 | 0.000 | 0.000 | 0.000 | 0.251 | 0.905 | 1.000 |
| X | Y | objectid | businessunit_name | businessunit_number | businessunit_banner_description | businessunit_type_description | businessunit_isstoreopen | facilitydetails_location_locati | facilitydetails_location_loca_1 | facilitydetails_location_loca_2 | facilitydetails_location_loca_3 | facilitydetails_location_loca_8 | businessunit_status_code | op_status | Modified_Operating_Hours_ | Pharmacy_open_to_public_ | Fuel_Station_open_to_public_ | bu_num | Grocery_delivery_service | Grocery_delivery_status | Online_grocery_pickup | Online_grocery_pickup_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | -94.149054 | 36.331300 | 29040 | ROGERS, AR | 1 | WM Supercenter | Retail | True | 2110 W WALNUT ST | ROGERS | BENTON | AR | 72756-3246 | 5 | Open | NaN | Y | Y | 1 | Yes | NaN | Yes | Not Available |
| 1 | -66.642578 | 17.997360 | 29045 | PONCE-PR | 2026 | WM Supercenter | Retail | True | 3305 AVE.BARAMAYA SUITE 100 | PONCE | PONCE | PR | 00728-0000 | 5 | Open | NaN | Y | Y | 2026 | NaN | NaN | Yes | NaN |
| 2 | -97.477003 | 25.925142 | 29046 | BROWNSVILLE TX | 1000 | WM Supercenter | Retail | True | 2721 BOCA CHICA BLVD | BROWNSVILLE | CAMERON | TX | 78521-3501 | 5 | Open | NaN | Y | Y | 1000 | Yes | NaN | Yes | Available |
| 3 | -78.835052 | 39.624903 | 29047 | LAVALE, MD | 2027 | WM Supercenter | Retail | True | 12500 COUNTRY CLUB MALL RD | LAVALE | ALLEGANY | MD | 21502-7553 | 5 | Open | NaN | Y | Y | 2027 | Yes | Available | Yes | Available |
| 4 | -104.664898 | 38.232316 | 29048 | PUEBLO, CO | 1001 | WM Supercenter | Retail | True | 4080 W NORTHERN AVE | PUEBLO | PUEBLO | CO | 81005-3503 | 5 | Open | NaN | Y | Y | 1001 | Yes | Available | Yes | Available |
| 5 | -117.455339 | 33.937071 | 29049 | RIVERSIDE (S), CA | 2028 | WM Supercenter | Retail | True | 5200 VAN BUREN BLVD | RIVERSIDE | RIVERSIDE | CA | 92503-2544 | 5 | Open | NaN | Y | Y | 2028 | No | NaN | Yes | NaN |
| 6 | -87.130708 | 39.035877 | 29050 | LINTON IN | 1002 | WM Supercenter | Retail | True | 2251 E STATE HIGHWAY 54 | LINTON | GREENE | IN | 47441-9498 | 5 | Open | NaN | Y | Y | 1002 | Yes | NaN | Yes | NaN |
| 7 | -93.072743 | 39.767888 | 29053 | BROOKFIELD MO | 203 | WM Supercenter | Retail | True | 937 PARK CIRCLE DR | BROOKFIELD | LINN | MO | 64628-7920 | 5 | Open | NaN | Y | Y | 203 | No | NaN | Yes | NaN |
| 8 | -92.479644 | 42.701631 | 29056 | WAVERLY IA | 1005 | WM Supercenter | Retail | True | 2700 4TH ST SW | WAVERLY | BREMER | IA | 50677-4351 | 5 | Open | NaN | Y | Y | 1005 | Yes | Available | Yes | Available |
| 9 | -122.067308 | 37.604715 | 29057 | UNION CITY, CA | 2031 | Wal-Mart | Retail | True | 30600 DYER ST | UNION CITY | ALAMEDA | CA | 94587-1717 | 2 | Open | NaN | Y | Y | 2031 | Yes | NaN | Yes | NaN |
| X | Y | objectid | businessunit_name | businessunit_number | businessunit_banner_description | businessunit_type_description | businessunit_isstoreopen | facilitydetails_location_locati | facilitydetails_location_loca_1 | facilitydetails_location_loca_2 | facilitydetails_location_loca_3 | facilitydetails_location_loca_8 | businessunit_status_code | op_status | Modified_Operating_Hours_ | Pharmacy_open_to_public_ | Fuel_Station_open_to_public_ | bu_num | Grocery_delivery_service | Grocery_delivery_status | Online_grocery_pickup | Online_grocery_pickup_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3606 | -82.455718 | 29.063309 | 36688 | DUNNELLON FL | 960 | WM Supercenter | Retail | True | 11012 NO. WILLIAMS ST | DUNNELLON | MARION | FL | 34432-8310 | 5 | Open | NaN | Y | Y | 960 | Yes | Available | Yes | Available |
| 3607 | -90.498285 | 30.074716 | 36690 | LAPLACE LA | 961 | WM Supercenter | Retail | True | 1616 W AIRLINE HWY | LA PLACE | ST. JOHN THE BAPTIST PARISH | LA | 70068-3331 | 5 | Open | NaN | Y | Y | 961 | No | Available | Yes | Available |
| 3608 | -104.523275 | 37.138728 | 36693 | TRINIDAD CO | 962 | WM Supercenter | Retail | True | 2921 TOUPAL DR | TRINIDAD | LAS ANIMAS | CO | 81082-8740 | 5 | Open | NaN | Y | Y | 962 | Yes | Available | Yes | Available |
| 3609 | -97.794862 | 32.731493 | 36695 | WEATHERFORD TX | 963 | WM Supercenter | Retail | True | 1836 S MAIN ST | WEATHERFORD | PARKER | TX | 76086-5506 | 5 | Open | NaN | Y | Y | 963 | No | Available | Yes | Available |
| 3610 | -106.311596 | 31.682898 | 36698 | EL PASO (S) TX | 964 | WM Supercenter | Retail | True | 9441 ALAMEDA AVE | EL PASO | EL PASO | TX | 79907-5601 | 5 | Open | NaN | Y | Y | 964 | Yes | Available | Yes | Available |
| 3611 | -90.508577 | 44.021024 | 36700 | TOMAH WI | 965 | WM Supercenter | Retail | True | 222 W MCCOY BLVD | TOMAH | MONROE | WI | 54660-3291 | 5 | Open | NaN | Y | Y | 965 | No | NaN | Yes | NaN |
| 3612 | -108.561994 | 37.346568 | 36702 | CORTEZ CO | 966 | WM Supercenter | Retail | True | 1835 E MAIN ST | CORTEZ | MONTEZUMA | CO | 81321-3037 | 5 | Open | NaN | Y | Y | 966 | Yes | NaN | Yes | NaN |
| 3613 | -82.631218 | 28.458397 | 36704 | SPRINGHILL / BROOKSVILLE | 967 | WM Supercenter | Retail | True | 1485 COMMERCIAL WAY | SPRING HILL | HERNANDO | FL | 34606-4525 | 5 | Open | NaN | Y | Y | 967 | Yes | Available | Yes | Available |
| 3614 | -81.722251 | 28.006651 | 36705 | WINTER HAVEN FL | 968 | WM Supercenter | Retail | True | 355 CYPRESS GARDENS BLVD | WINTER HAVEN | POLK | FL | 33880-4452 | 5 | Open | NaN | Y | Y | 968 | Yes | Available | Yes | Available |
| 3615 | -89.088697 | 30.423224 | 36706 | GULFPORT MS | 969 | WM Supercenter | Retail | True | 9350 HIGHWAY 49 | GULFPORT | HARRISON | MS | 39503-4213 | 5 | Open | NaN | Y | Y | 969 | No | Not Available | Yes | Available |